Dashboard 02 - WakeCountyRealEstate Dashboard - Creating Scatter Chart, Map, & Line and Stacked Column charts Visualizations - Part 01 13
In this step, we will continue working on the first dashboard. We
will create Scatter Chart, Map, & Line and Clustered Column chart
Step 1: Create Scatter Chart for AVG YOY Apt. & House Prices/Sq. Ft. by Township
In Power BI Desktop, click on the page, WakeCountyRealEstate
Click inside the pane
Visualizations
Click the Scatter Chart icon
Fields
Select the following:
Under Visualizations, drag & drop it in the Details section:
Township -> .Township_Name
Township -> .Township_Misc_Name
Under Visualizations, drag & drop it in the X Axis:
A_KeyMeasures -> .YOY_AVG_AptUnitPrice_PerSqFt%
Under Visualizations, drag & drop it in the Y Axis section:
A_KeyMeasures -> .YOY_AVG_ResidentialPrice_PerSqFt%
Under Visualizations, drag & drop it in the Size section:
A_KeyMeasures -> .Total_Properties
Under Visualizations, drag & drop it in the Tooltips section the following:
A_KeyMeasures -> .AVG_AptUnitPrice_PerSqFt
A_KeyMeasures -> .AVG_ResidentialPrice_PerSqFt
A_KeyMeasures -> .AVG_Residential_Prices
Township -> .Township_Misc_Name
Visualizations
Fields tab
Under Fields tab, click on the down arrow -> Rename for this visual and rename the fields as follows:
.Township_Name = Township Name
.Township_Misc_Name = Township Misc. Name(s)
.YOY_AVG_AptUnitPrice_PerSqFt% = AVG YOY Apt Price/SqFt
.YOY_AVG_ResidentialPrice_PerSqFt% = AVG YOY Hse Price/SqFt
.Total_Properties = Total Properties
.AVG_AptUnitPrice_PerSqFt = AVG Apt Price/SqFt
.AVG_ResidentialPrice_PerSqFt = AVG Hse Price/SqFt
.AVG_Residential_Prices = AVG House Price
.Township_Misc_Name = Township Misc. Name(s)
Format tab
To format the visual, beneath the Visualizations pane, select the Format pane.
Under Format -> General: X Position = 272 , Y Position = 172 , Width = 615 , Height = 467
Under Format -> X Axis -> Scale Type = Linear -> Color = #1D0D49 , Text Size = 12 pt , Font Family = Segoe UI , Title = ON , Style = Show Title Only , Title Color = #1D0D49, Title Text Size = 14 pt, Font Family = DIN , Gridlines = ON , Line Color = #6D5A00 , Stroke Width 2 , Line Style = Dotted
Under Format -> Y Axis -> Position = Left , Scale Type = Linear -> Color = #925231 , Text Size = 12 pt , Font Family = Segoe UI , Style = Show Title Only , Title Color = #925231, Title Text Size = 14 pt, Font Family = DIN , Gridlines = ON , Line Color = #6B2328 , Stroke Width 2 , Line Style = Dotted
Under Format -> Data Colors -> click fx for Expression -> Format by = Field Value, Based on Field = .Measure_Color
Under Format -> Shapes -> Size = 10 , Marker Shape = . (dot)
Under Format -> Category -> Set it to ON , Color = #000000, Text Size = 14 pt , Font Family = Segoe UI
Under Format -> Category -> Set it to ON
Under Format -> Color by Category -> Set it to OFF
Under Format -> Title -> Set it to ON , Title Text = AVG YOY Apt. & House Prices/Sq. Ft. by Township , Font Color = #1D0C4A , Background Color = E6E6E6 , Alignment = Center , Text Size = 20 pt , Font Family = DIN (Default)
Under Format -> Background -> Set it to ON , Color = #FFFFFF
Under Format -> Border -> Set it to ON , Color = 666666, Radius = 5 px
Under Format -> Tooltip -> Set it to ON
Final look:
Step 3: Create Apartments & Houses by Township Map
Click inside the pane
Visualizations
Click the Map
Fields
Select the following:
Under Visualizations, drag & drop it in the Latitude section:
Township -> Latitude_Township
Under Visualizations, drag & drop it in the Longitude section:
Township -> Longitude_Township
Under Visualizations, drag & drop it in the Size section:
A_KeyMeasures -> .Total_Residentials
Under Visualizations, drag & drop it in the Tooltips section:
A_KeyMeasures -> .Total_AptUnits
A_KeyMeasures -> .YOY_Diff_AVG_AptUnitPrice_PerSqFt%
A_KeyMeasures -> .YOY_Diff_AVG_ResidentialPrice_PerSqFt%
Township -> .Township_Name
Township -> .Township_Misc_Name
Visualizations
Fields tab
Under Fields tab, click on the down arrow -> Rename for this visual and rename the fields as follows:
Latitude_Township = Latitude
Longitude_Township = Longitude
.Total_Residentials = Total Houses
.Total_AptUnits = Total Apartment Units
.YOY_Diff_AVG_AptUnitPrice_PerSqFt% = YOY AVG Apt Price/Sq. Ft.
.YOY_Diff_AVG_ResidentialPrice_PerSqFt% = YOY AVG House Price/Sq. Ft.
.Township_Name = Township Name
.Township_Misc_Name = Township Misc. Name
Format tab
To format the visual, beneath the Visualizations pane, select the Format pane.
Under Format -> General: X Position = 887 , Y Position = 172 , Width = 613 , Height = 467
Under Format -> Data Colors -> click fx for Expression -> Format by = Field Value, Based on Field = .Measure_Color
Under Format -> Category -> Set it to OFF
Under Format -> Bubbles -> Size = 40
Under Format -> Map Controls -> Auto Zoom = ON , Zoom Buttons = ON
Under Format -> Title -> Set it to ON , Title Text = Apartments & Houses by Township , Font Color = #1D0C4A , Background Color = E6E6E6 , Alignment = Center , Text Size = 20 pt , Font Family = DIN (Default)
Under Format -> Background -> Set it to ON , Color = E6E6E6
Under Format -> Border -> Set it to ON , Color = 666666
Filters
N/A
When finished, save project.
Tips and Tricks for Maps in Power BI